﻿
IF (EXISTS(SELECT id from sysobjects where id=object_id('usp_UpdateElection')))
	DROP PROCEDURE [dbo].[usp_UpdateElection]
GO

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

create procedure usp_UpdateElection
@ElectionId  as int,
@ElectionDescription  as nvarchar(50),
@ElectionDate  as DateTime,
@ElectionResultDate  as DateTime


as

update TblElection 
set 
ElectionDescription = @ElectionDescription,
ElectionDate = @ElectionDate,
ElectionResultDate = @ElectionResultDate

where
ElectionId = @ElectionId